{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Recording Macros:"]
[]
[null,null,"If the DEVELOPER tab is not showing at the top of the Excel window, then go to"]
[null,null,"the Excel options and select POPULAR on the side menu, then check"]
[null,null,"SHOW DEVELOPER TAB IN THE RIBBON. Click OK to close the window."]
[]
[null,null,"You also need to set the security level to temporarily enable all macros."]
[null,null,"On the DEVELOPER tab, click MACRO SECURITY and then under MACRO SETTINGS"]
[null,null,"check the box for ENABLE ALL MACROS."]
[]
[null,null,"Note the USE RELATIVE REFERENCES button under CODE. With this OFF, the macro"]
[null,null,"will perform its function only in the cell you recorded the macro in. With this set to"]
[null,null,"ON, it will perform its function relative to where you start it."]
[null,null,"Now click on RECORD MACRO. In the window that pops up, give the macro"]
[null,null,"a name and a key to activate it. Also select where you want it to be stored. If"]
[null,null,"you select PERSONAL MACRO WORKBOOK, the macro will be available any"]
[null,null,"time you are working in Excel. If you choose the option to store it in the current"]
[null,null,"workbook, it will only be available in this one workbook."]
[]
[null,null,"Now perform whatever action you want to record in the macro. This can be"]
[null,null,"any series of actions you can do with the keyboard or the mouse. Click"]
[null,null,"STOP RECORDING when you are done. Then try it out to make sure it works."]
[]
[null,null,"Macros can contain other macros, too. "]
[]
[null,null,"Now click the MACROS icon and then select EDIT. This"]
[null,null,"shows you the Visual Basic for Applications (VBA) code for the macro. You can"]
[null,null,"edit this code to change the macro, or you can use the code for one macro to"]
[null,null,"make a similar one that works a little differently."]
[]
[null,null,"Try to save the file in the usual way and you will get a warning that you can't save"]
[null,null,"the file as a regular Excel workbook. In the window that pops up, click on NO and then "]
[null,null,"in the next window that pops up, change the file type to Excel Macro-Enabled Workbook."]
[null,null,"That should let you save the workbook"]
[]
[]
[null,"Inserting and Using Controls:"]
[]
[null,null,"On the DEVELOPER tab, click on the INSERT icon."]
[null,null,"In the FORM CONTROLS, select the CHECK BOX, and then place it in your document."]
[null,null,"Notice that you can check uncheck it by clicking on it. "]
[null,null,"RIGHT CLICK on the control and note the options. You can edit the text, group this control"]
[null,null,"with others, change the order that this control appears on the page layered with other things."]
[null,null,"Select FORMAT CONTROL. In that window, click the CONTROL tab and note that you can"]
[null,null,"provide a CELL LINK. Try that out and see what happens then when you check and uncheck"]
[null,null,"the control. This allows the control to provide input to formulas in the spreadsheet."]
[null,null,"RIGHT CLICK on the control again and select ASSIGN MACRO. Assign one of the macros"]
[null,null,"you created in the previous section. See how it works by checking or unchecking the box."]
[null,null,"What could you do with the feature?"]
[null,null,"Note the other types of form controls that are available."]
[null,null,"The ActiveX controls are very powerful but also are more difficult to use. They give you"]
[null,null,"MUCH more control over how the object looks and behaves. Compare the regular and"]
[null,null,"ActiveX checkbox controls to see how they differ."]
[]
[null,null,"Experiment with the different types of controls and use some of them to enhance the"]
[null,null,"capital budgeting and amortization tables we have created in previous sessions."]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}